﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class vp_Billing_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        GridView1.DataSource = GetTable();
        GridView1.DataBind();

    }

    private DataTable GetTable()
    {

        DataTable dtbl1 = new DataTable();


        dtbl1.Columns.Add("User Type", typeof(string));
        dtbl1.Columns.Add("User Name", typeof(string));
        dtbl1.Columns.Add("Product Code", typeof(string));
        dtbl1.Columns.Add("Category Code", typeof(string));
        dtbl1.Columns.Add("Price", typeof(int));
        dtbl1.Columns.Add("Discount", typeof(int));

        dtbl1.Rows.Add("Agent", "Name1", "Product01","Category01",192,10);
        dtbl1.Rows.Add("Jeweller", "Name2", "Product01", "Category02",201,14);
        dtbl1.Rows.Add("Reseller", "Name3", "Product01", "Category03",185,0);
        dtbl1.Rows.Add("Agent", "Name4", "Product02", "Category01",95,0);

        return dtbl1;
    }
}